package com.wmuj.mapper;

import com.wmuj.pojo.OperLogQueryParam;
import com.wmuj.pojo.OperateLog;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface OperateLogMapper {

  // 插入日志数据
  @Insert(
      "insert into operate_log (operate_emp_id, operate_time, class_name, method_name, method_params, return_value, cost_time) "
          + "values (#{operateEmpId}, #{operateTime}, #{className}, #{methodName}, #{methodParams}, #{returnValue}, #{costTime});")
  public void insert(OperateLog log);

  // 查询日志数据

  @Select("select * from operate_log order by id desc")
  List<OperateLog> getLogInfo(OperLogQueryParam operLogQueryParam);

  @Select("select e.name from emp e where e.id = #{operateEmpId}")
  String findEmpNameById(Integer operateEmpId);
}
